﻿using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Text;

namespace KPIS.GERP.SERVICE.Model
{
    public class GERPContext : DbContext//MySql.Data.MySqlClient.MySqlDbContext
    {
        public DbSet<hrm_ps_absence> hrm_ps_absence { get; set; }

        public DbSet<hrm_ps_absence_type> hrm_ps_absence_type { get; set; }

        public DbSet<hrm_ps_employees> hrm_ps_employees { get; set; }

        public DbSet<mas_genders> mas_genders { get; set; }

        public DbSet<mas_districts> mas_districts { get; set; }

        public DbSet<mas_amphurs> mas_amphurs { get; set; }
        //public DbSet<approval_task> approval_task { get; set; }
        public DbSet<message> message { get; set; }
        //public DbSet<message_warning> message_warning { get; set; }
        //public DbSet<rule_absence> rule_absence { get; set; }
        //public DbSet<rule_approve> rule_approve { get; set; }
        public DbSet<sys_sc_users> sys_sc_users { get; set; }

        //public DbSet<mas_name_prefixes> mas_name_prefixes { get; set; }
        //public DbSet<mas_genders> mas_genders { get; set; }
        //public DbSet<mas_blood_groups> mas_blood_groups { get; set; }
        //public DbSet<mas_religions> mas_religions { get; set; }
        //public DbSet<mas_nationalities> mas_nationalities { get; set; }
        public DbSet<hrm_ps_employee_types> hrm_ps_employee_types { get; set; }
        //public DbSet<hrm_ps_employee_statuses> hrm_ps_employee_statuses { get; set; }
        public DbSet<hrm_mp_classes> hrm_mp_classes { get; set; }
        public DbSet<hrm_mp_positions> hrm_mp_positions { get; set; }
        public DbSet<hrm_mp_job_sites> hrm_mp_job_sites { get; set; }
        public DbSet<hrm_mp_exec_positions> hrm_mp_exec_positions { get; set; }
        
        //public DbSet<mas_marital_statuses> mas_marital_statuses { get; set; }

        public DbSet<hrm_ps_commands> hrm_ps_commands { get; set; }
        public DbSet<hrm_ps_command_types> hrm_ps_command_types { get; set; }
        public DbSet<hrm_ps_command_dtls> hrm_ps_command_dtls { get; set; }
        public DbSet<hrm_ps_emp_position_histories> hrm_ps_emp_position_histories { get; set; }
        public DbSet<hrm_ps_emp_salary_histories> hrm_ps_emp_salary_histories { get; set; }

        public DbSet<hrm_dc_penalty> hrm_dc_penalty { get; set; }

        public DbSet<mas_provinces> mas_provinces { get; set; }

        //protected override void OnModelCreating(DbModelBuilder modelBuilder)
        //{
        //    modelBuilder.Entity<hrm_mp_field_positions>()
        //        .HasRequired(c => c.hrm_mp_class_specifications)
        //        .WithMany()
        //        .Map(p => p.MapKey("FkFieldClassSpecClassSpecSeq"))
        //        ;
        //}
    }
}
